Listing Tools

An unusual offering with possibilities limited only by your imagination! Could this be the dream come to reality-one property where you can live, work, create and generate rental income to help pay the mortgage?Set on 2.6 beautiful, private acres, this distinctive property includes a single-family home, a separate two-family home, and an impressive 28' x 56' fully restored barn. Thoughtfully positioned with plenty of privacy between the buildings, the property offers a rare combination of residential, rental and workspaces.The main home features a wonderful addition with a charming tower room that could become your home office, bedroom, studio, reading retreat or meditation space-the choice is yours. The separate two-family home provides excellent potential for rental income, extended family, guests or additional living arrangements.The fully restored barn is a standout feature, offering substantial flexible space for a workshop, studio, home business, creative pursuits, storage or other possibilities. The barn is set up for radiant heat, for you to make it a truly usable year-round space.Modern mechanical systems in both residential buildings add comfort and peace of mind while preserving the property's unique character. With multiple buildings, generous acreage and an extraordinary blend of living, working and income-producing potential, this is far more than a home-it is an opportunity to create the lifestyle and property you've been imagining.Rarely does a property offer this much flexibility, privacy and potential in one package. Come explore the possibilities and decide what your dream looks like here.

More Info

Basic Information

  • Lot Features Wooded, Cleared, Gentle Sloping, Level
  • Mls StatusActive
  • Parcel Number 3624861
  • Road Frontage DescriptionPaved

Tax Information

  • Tax Assessed Value $581,200
  • Tax Year 2026
  • Taxes$8,526

Parking

  • Covered Spaces 3
  • Garage YN Yes
  • Open Parking YN Yes
  • Parking Features Off Street, Unpaved
  • Parking Spaces23

Rooms

  • Bathroom4
  • Bathrooms Total Decimal 3.5
  • Bedrooms8
  • Full Bath3
  • Half Baths1

Basic Information

  • List Price$699,000
  • MLS Number73563072
  • Modification Date10/05/2026
  • Property SubType3 Family

Location

  • Address497 Main Street
  • Building Number497
  • CountyHampshire
  • StateMA
  • StreetMain Street
  • TownHatfield
  • Zip01038

Building

  • BasementFull, Bulkhead, Sump Pump, Concrete
  • Building Area Units Square Feet
  • Construction Materials Frame
  • FireplaceYes
  • Fireplaces Total 1
  • FoundationStone, Brick/Mortar
  • Garage Spaces3
  • Levels 5
  • Patio And Porch Features Porch
  • Rooms15
  • Stories5
  • Units3
  • Utilities For Gas Range, For Electric Range, For Gas Dryer, Washer Hookup, Varies Per Unit
  • Year Built1900
  • Year Built Details Approximate
  • Year Built Source Public Records

Property

  • Acreage2.6
  • Frontage Length 178
  • Other Structures Barn/Stable

Interior

  • Flooring Wood, Tile, Vinyl, Varies
  • Interior Features Living Room, Dining Room, Kitchen, Laundry Room

Exterior

  • Exterior Features Varies per Unit, Garden
  • RoofShingle

Utilities

  • Electric 100 Amp Service,200+ Amp Service, Individually Metered, Varies per Unit
  • Heat SystemYes
  • Heating
    • Baseboard
    • Individual
    • Leased Propane Tank
    • Natural Gas
    • Radiant
    • Wood Stove
  • Sewer Private Sewer
  • Water Source Public

Property Information

  • Building Area Source Public Records
  • Living Area 4,698
  • Lot Size Square Feet 113,391
  • Lot Size Units Acres
  • Road Responsibility Public Maintained Road
  • Square Feet4,698

Amenities

  • Amenities
    • Highway Access
    • House of Worship
    • Medical Facility
    • Private School
    • T-Station
    • University
  • Appliances IncludedOven, Dishwasher, Microwave, Range, Refrigerator, Washer, Dryer
  • Other AmenitiesBasement, Fireplace, Garden

Other

  • Date Listed08/13/2026
  • Farm Land Area Units Square Feet
  • View Count2

Map Location

Driving Directions

Listed by Ilene Berezin of The Murphys REALTORS®,Inc.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Castles Unlimited. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.